/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80030 (8.0.30)
 Source Host           : localhost:3306
 Source Schema         : xxx-chat

 Target Server Type    : MySQL
 Target Server Version : 80030 (8.0.30)
 File Encoding         : 65001

 Date: 06/11/2023 02:56:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_app
-- ----------------------------
DROP TABLE IF EXISTS `base_app`;
CREATE TABLE `base_app` (
  `app_id` int NOT NULL AUTO_INCREMENT,
  `app_type` int DEFAULT '0',
  `app_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `short_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `app_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sms_sign_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sms_template_code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sms_config` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `add_time` int DEFAULT NULL,
  `edt_time` int DEFAULT NULL,
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_app
-- ----------------------------
BEGIN;
INSERT INTO `base_app` (`app_id`, `app_type`, `app_name`, `short_name`, `app_logo`, `sms_sign_name`, `sms_template_code`, `sms_config`, `add_time`, `edt_time`) VALUES (1, 0, NULL, NULL, NULL, '酷72', 'SMS_152548485', 'fanyu', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_app_setting
-- ----------------------------
DROP TABLE IF EXISTS `base_app_setting`;
CREATE TABLE `base_app_setting` (
  `app_id` int NOT NULL,
  `about_us_article` int DEFAULT NULL,
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of base_app_setting
-- ----------------------------
BEGIN;
INSERT INTO `base_app_setting` (`app_id`, `about_us_article`) VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for base_article
-- ----------------------------
DROP TABLE IF EXISTS `base_article`;
CREATE TABLE `base_article` (
  `article_id` int NOT NULL AUTO_INCREMENT,
  `article_class_id` int DEFAULT NULL,
  `app_id` int DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `useable` int DEFAULT '1',
  `add_time` int DEFAULT NULL,
  `edt_time` int DEFAULT NULL,
  PRIMARY KEY (`article_id`) USING BTREE,
  KEY `article_class_id` (`article_class_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_article
-- ----------------------------
BEGIN;
INSERT INTO `base_article` (`article_id`, `article_class_id`, `app_id`, `title`, `subtitle`, `logo`, `content`, `useable`, `add_time`, `edt_time`) VALUES (1, NULL, 1, '关于我们', '关于我们', '/article/1667729468818.png', '', 1, 1668544920, 1668586987);
INSERT INTO `base_article` (`article_id`, `article_class_id`, `app_id`, `title`, `subtitle`, `logo`, `content`, `useable`, `add_time`, `edt_time`) VALUES (2, NULL, 1, '服务协议', '《服务协议》', '/article/1667729468818.png', '', 1, 1668544955, 1668587126);
INSERT INTO `base_article` (`article_id`, `article_class_id`, `app_id`, `title`, `subtitle`, `logo`, `content`, `useable`, `add_time`, `edt_time`) VALUES (3, NULL, 1, '隐私协议', '《隐私协议》', '/article/1667729468818.png', '', 1, 1668544955, 1668587139);
COMMIT;

-- ----------------------------
-- Table structure for base_article_class
-- ----------------------------
DROP TABLE IF EXISTS `base_article_class`;
CREATE TABLE `base_article_class` (
  `article_class_id` int NOT NULL AUTO_INCREMENT,
  `app_id` int DEFAULT NULL,
  `article_class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `article_class_sub` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `article_class_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort` int DEFAULT '1',
  `useable` int DEFAULT '1',
  `add_time` int DEFAULT NULL,
  `edt_time` int DEFAULT NULL,
  PRIMARY KEY (`article_class_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_article_class
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_crontab
-- ----------------------------
DROP TABLE IF EXISTS `base_crontab`;
CREATE TABLE `base_crontab` (
  `crontab_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rule` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rule_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `callback` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `useable` int DEFAULT '1',
  `deleted` int DEFAULT '0',
  `last_run_time` int DEFAULT NULL,
  `add_time` int DEFAULT NULL,
  PRIMARY KEY (`crontab_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_crontab
-- ----------------------------
BEGIN;
INSERT INTO `base_crontab` (`crontab_id`, `name`, `rule`, `rule_desc`, `callback`, `useable`, `deleted`, `last_run_time`, `add_time`) VALUES (1, '间隔1秒执行', '* * * * * *', '间隔1秒执行', '\\app\\task\\Test::queue_test_1', 0, 1, 1697309363, NULL);
INSERT INTO `base_crontab` (`crontab_id`, `name`, `rule`, `rule_desc`, `callback`, `useable`, `deleted`, `last_run_time`, `add_time`) VALUES (2, '间隔1秒执行', '* * * * * *', '间隔1秒执行', '\\app\\task\\Test::queue_test_2', 0, 1, 1697309363, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_crontab_log
-- ----------------------------
DROP TABLE IF EXISTS `base_crontab_log`;
CREATE TABLE `base_crontab_log` (
  `crontab_log_id` int NOT NULL AUTO_INCREMENT,
  `crontab_id` int DEFAULT NULL,
  `start_time` int DEFAULT NULL,
  `end_time` int DEFAULT NULL,
  `run_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `log_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`crontab_log_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3731320 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_crontab_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_exception_logs
-- ----------------------------
DROP TABLE IF EXISTS `base_exception_logs`;
CREATE TABLE `base_exception_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `exp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `line` int DEFAULT NULL,
  `add_time` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_exception_logs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_friends
-- ----------------------------
DROP TABLE IF EXISTS `base_friends`;
CREATE TABLE `base_friends` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mine_user_id` int NOT NULL COMMENT '用户uid',
  `friend_user_id` int NOT NULL COMMENT '好友uid',
  `mobile` varchar(50) DEFAULT NULL,
  `tags` json DEFAULT NULL,
  `remark` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `pic_lst` json DEFAULT NULL,
  `add_time` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid1` (`mine_user_id`,`friend_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of base_friends
-- ----------------------------
BEGIN;
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (1, 10001, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (2, 10001, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (3, 10001, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (4, 10001, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (5, 10001, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (6, 10001, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (7, 10001, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (8, 10001, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (9, 10001, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (10, 10001, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (11, 10001, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (12, 10002, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (13, 10002, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (14, 10002, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (15, 10002, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (16, 10002, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (17, 10002, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (18, 10002, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (19, 10002, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (20, 10002, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (21, 10002, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (22, 10002, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (23, 10003, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (24, 10003, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (25, 10003, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (26, 10003, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (27, 10003, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (28, 10003, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (29, 10003, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (30, 10003, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (31, 10003, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (32, 10003, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (33, 10003, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (34, 10004, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (35, 10004, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (36, 10004, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (37, 10004, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (38, 10004, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (39, 10004, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (40, 10004, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (41, 10004, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (42, 10004, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (43, 10004, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (44, 10004, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (45, 10005, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (46, 10005, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (47, 10005, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (48, 10005, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (49, 10005, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (50, 10005, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (51, 10005, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (52, 10005, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (53, 10005, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (54, 10005, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (55, 10005, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (56, 10006, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (57, 10006, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (58, 10006, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (59, 10006, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (60, 10006, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (61, 10006, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (62, 10006, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (63, 10006, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (64, 10006, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (65, 10006, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (66, 10006, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (67, 10007, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (68, 10007, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (69, 10007, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (70, 10007, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (71, 10007, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (72, 10007, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (73, 10007, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (74, 10007, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (75, 10007, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (76, 10007, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (77, 10007, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (78, 10008, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (79, 10008, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (80, 10008, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (81, 10008, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (82, 10008, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (83, 10008, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (84, 10008, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (85, 10008, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (86, 10008, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (87, 10008, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (88, 10008, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (89, 10009, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (90, 10009, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (91, 10009, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (92, 10009, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (93, 10009, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (94, 10009, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (95, 10009, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (96, 10009, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (97, 10009, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (98, 10009, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (99, 10009, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (100, 10010, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (145, 10010, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (146, 10010, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (147, 10010, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (148, 10010, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (149, 10010, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (150, 10010, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (151, 10010, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (152, 10010, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (153, 10010, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (154, 10010, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (155, 10011, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (156, 10011, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (157, 10011, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (158, 10011, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (159, 10011, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (160, 10011, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (161, 10011, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (162, 10011, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (163, 10011, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (164, 10011, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (165, 10011, 10012, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (166, 10012, 10001, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (167, 10012, 10002, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (168, 10012, 10003, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (169, 10012, 10004, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (170, 10012, 10005, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (171, 10012, 10006, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (172, 10012, 10007, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (173, 10012, 10008, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (174, 10012, 10009, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (175, 10012, 10010, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `base_friends` (`id`, `mine_user_id`, `friend_user_id`, `mobile`, `tags`, `remark`, `description`, `pic_lst`, `add_time`) VALUES (176, 10012, 10011, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_group
-- ----------------------------
DROP TABLE IF EXISTS `base_group`;
CREATE TABLE `base_group` (
  `gid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '群组id',
  `groupname` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '群组名称',
  `avatar` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'https://file.flower4cn.com/group.png' COMMENT '群组图标',
  `creator` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '创建者',
  `add_time` int unsigned NOT NULL COMMENT '创建时间戳',
  PRIMARY KEY (`gid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_group
-- ----------------------------
BEGIN;
INSERT INTO `base_group` (`gid`, `groupname`, `avatar`, `creator`, `add_time`) VALUES (1, '十二生肖大联欢', 'https://file.flower4cn.com/12sx-300.png', '10001', 1698685592);
COMMIT;

-- ----------------------------
-- Table structure for base_group_members
-- ----------------------------
DROP TABLE IF EXISTS `base_group_members`;
CREATE TABLE `base_group_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gid` int NOT NULL COMMENT '群组id',
  `uid` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户uid',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `gid` (`gid`,`uid`) USING BTREE,
  UNIQUE KEY `gid_2` (`gid`,`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_group_members
-- ----------------------------
BEGIN;
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (1, 1, '10001');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (2, 1, '10002');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (3, 1, '10003');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (4, 1, '10004');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (5, 1, '10005');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (6, 1, '10006');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (7, 1, '10007');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (8, 1, '10008');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (9, 1, '10009');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (10, 1, '10010');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (11, 1, '10011');
INSERT INTO `base_group_members` (`id`, `gid`, `uid`) VALUES (12, 1, '10012');
COMMIT;

-- ----------------------------
-- Table structure for base_login_record
-- ----------------------------
DROP TABLE IF EXISTS `base_login_record`;
CREATE TABLE `base_login_record` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `comments` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `app_id` int DEFAULT NULL,
  `add_time` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=403443 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_login_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_message
-- ----------------------------
DROP TABLE IF EXISTS `base_message`;
CREATE TABLE `base_message` (
  `hid` int unsigned NOT NULL AUTO_INCREMENT COMMENT '消息id',
  `from` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '发起者uid',
  `to` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '接收者id，根据type不同，可能是用户uid，可能是群组id',
  `data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '具体的消息数据',
  `type` enum('friend','group') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `is_read` int DEFAULT '0',
  `timestamp` int unsigned NOT NULL COMMENT '消息时间戳',
  PRIMARY KEY (`hid`) USING BTREE,
  KEY `timestamp` (`timestamp`) USING BTREE,
  KEY `from` (`from`) USING BTREE,
  KEY `to` (`to`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of base_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for base_user
-- ----------------------------
DROP TABLE IF EXISTS `base_user`;
CREATE TABLE `base_user` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `referrer_id` int DEFAULT '0',
  `level_id` int DEFAULT '0',
  `group_id` int DEFAULT '0',
  `app_id` int DEFAULT NULL,
  `usercode` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` blob,
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像地址',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机',
  `sex` int DEFAULT NULL COMMENT '性别',
  `realname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '真实姓名',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'email账号',
  `qq` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `longitude` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '经度',
  `latitude` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '纬度',
  `useable` int DEFAULT '1' COMMENT '可用状态',
  `deleted` int DEFAULT '0',
  `registration_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '注册IP',
  `last_login_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '最后登录IP',
  `sign` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `last_login_time` int DEFAULT NULL COMMENT '最后登录时间',
  `logout_time` int DEFAULT '0' COMMENT '退出时间',
  `online_status` enum('online','offline') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'offline' COMMENT '在线状态',
  `add_time` int DEFAULT NULL COMMENT '创建时间',
  `edt_time` int DEFAULT NULL,
  `del_time` int DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `unique_key` (`app_id`,`mobile`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10014 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户';

-- ----------------------------
-- Records of base_user
-- ----------------------------
BEGIN;
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10000, 0, 0, 0, 1, 'com.xxx.chat', 0xE5BC80E58F91E59BA2E9989F, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/16991948050191', '18669099310', 1, '开发团队', '', '', NULL, NULL, 1, 0, NULL, '127.0.0.1', NULL, 1699207385, 1699207255, 'offline', NULL, 1699207246, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10001, 0, 0, 0, 1, 'Yoncron', 0xE9BE99E88081E5A4A7, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/1676582325340134.png', NULL, 1, '龙老大', '', '', '102.77864', '24.93355', 1, 0, '', '127.0.0.1', '让子弹飞一会儿.', 1699207500, 1699207396, 'offline', NULL, 1699199133, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10002, 0, 0, 0, 1, 'angerlambs', 0xE9BCA0E5B08FE5BC9FF09F9884, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/1698851948205131', NULL, 1, '鼠小弟', '', '', '102.77523', '24.93530', 1, 0, '', '127.0.0.1', NULL, 1699206840, 1699206827, 'offline', NULL, 1699102875, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10003, 0, 0, 0, 1, NULL, 0xE78CAAE585ABE68892, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169885167336543', NULL, 1, '猪八戒', '', '', '102.77988', '24.93095', 1, 0, '', '127.0.0.1', NULL, 1699200572, 1699200339, 'offline', NULL, 1699006585, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10004, 0, 0, 0, 1, NULL, 0xE7BE8AE592A9E592A9, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169885188495460', NULL, 1, '羊咩咩', '', '', '102.78795', '24.93629', 1, 0, '', '127.0.0.1', NULL, 1699200699, 1699200661, 'offline', NULL, 1699006634, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10005, 0, 0, 0, 1, NULL, 0xE78B97E5A4A7E4BEA0, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169900669296662', NULL, 1, '狗大侠', '', '', '102.77541', '24.93910', 1, 0, '', '127.0.0.1', NULL, 1699201625, 1699201599, 'offline', NULL, 1699006719, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10006, 0, 0, 0, 1, NULL, 0xE9B8A1E4B8ADE588BA, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169900674391534', NULL, 0, '鸡中刺', '', '', '102.76885', '24.94636', 1, 0, '', '127.0.0.1', NULL, 1699200815, 1699200776, 'offline', NULL, 1699006795, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10007, 0, 0, 0, 1, NULL, 0xE78CB4E593A5E593A5, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169900688240373', NULL, 1, '猴哥哥', '', '', '102.77272', '24.96086', 1, 0, '', '127.0.0.1', NULL, 1699200860, 1699200835, 'offline', NULL, 1699007414, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10008, 0, 0, 0, 1, NULL, 0xE9A9ACE99DA2E7949F, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/1699006938154148', NULL, 1, '马面生', '', '', '102.78651', '24.94404 ', 1, 0, '', '127.0.0.1', NULL, 1699201658, 1699201645, 'offline', NULL, 1699006966, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10009, 0, 0, 0, 1, NULL, 0xE89B87E5B08FE5A6B9, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/1699006989912125', NULL, 0, '蛇小妹', '', '', '102.77990', '24.93505', 1, 0, '', '127.0.0.1', NULL, 1699200990, 1699200926, 'offline', NULL, 1699007006, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10010, 0, 0, 0, 1, NULL, 0xE58594E585ABE593A5, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169900703363149', NULL, 1, '兔八哥', '', '', '102.77827', '24.93997', 1, 0, '', '127.0.0.1', NULL, 1699201101, 1699201010, 'offline', NULL, 1699007054, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10011, 0, 0, 0, 1, NULL, 0xE8998EE5A4A7E78E8B, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169900708236078', NULL, 1, '虎大王', '', '', '102.77515', '24.94258', 1, 0, '', '127.0.0.1', NULL, 1699201705, 1699201679, 'offline', NULL, 1699007273, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10012, 0, 0, 0, 1, NULL, 0xE7899BE8BDB0E8BDB0, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/1699007300577110', NULL, 1, '牛轰轰', '', '', '102.76731', '24.93894', 1, 0, '', '127.0.0.1', NULL, 1699201588, 1699201435, 'offline', NULL, 1699007331, NULL);
INSERT INTO `base_user` (`user_id`, `referrer_id`, `level_id`, `group_id`, `app_id`, `usercode`, `username`, `password`, `avatar`, `mobile`, `sex`, `realname`, `email`, `qq`, `longitude`, `latitude`, `useable`, `deleted`, `registration_ip`, `last_login_ip`, `sign`, `last_login_time`, `logout_time`, `online_status`, `add_time`, `edt_time`, `del_time`) VALUES (10013, 0, 0, 0, 1, 'ant8oo', 0xE89A82E89A81F09F909C, '4297f44b13955235245b2497399d7a93', 'https://file.flower4cn.com/avatar/169911041501686', '13529207045', 1, '蚂蚁牙黑', '', '', '102.76731', '24.93894', 1, 0, '', '127.0.0.1', NULL, 1699121856, 1699110390, 'offline', NULL, 1699110488, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
